﻿using NPOI.HSSF.UserModel;
using OMG.Fill.Mulberry.Model.Ent;
using OMG.Fill.Mulberry.Service;
using ProjectShare;
using System;
using System.Collections.Generic;
using System.IO;
using System.Text;
using System.Web;
using System.Web.Http;
namespace OMG.Fill.Mulberry.Model.UI.Controllers
{
    public class MulEggsProducStatistController : ApiController
    {
        MulEggsProducStatistServices mulEggsProducStatistServices = new MulEggsProducStatistServices();
        ReportServices reportServices = new ReportServices();
        DictServices dict = new DictServices();

        //[ApiActionAuthorize("获取表5蚕种生产情况统计表T_MulEggsProducStatist分页列表对象操作")]
        //[ApiActionException]
        public Pager<List<MulEggsProducStatistEntity>> PostPageList(MulEggsProducStatistQuery query)
        {
            return mulEggsProducStatistServices.GetPageList(query);
        }
        public ResResult<List<MulEggsStatsModel>> PostStatsList(MulNowModel model)
        {
            return mulEggsProducStatistServices.GetMulEggsProducStatsList(model);
        }
        //[ApiActionAuthorize("新增表5蚕种生产情况统计表T_MulEggsProducStatist指定对象操作")]
        //[ApiActionException]
        public ResResult<int> Post(List<MulEggsProducStatistEntity> model) {
            return mulEggsProducStatistServices.AddInfo(model);
        }
        //[ApiActionAuthorize("修改表5蚕种生产情况统计表T_MulEggsProducStatist指定对象操作")]
        //[ApiActionException]
        public ResResult<int> Put(MulEggsProducStatistEntity model)
        {
            return mulEggsProducStatistServices.UpdateInfo(model);
        }
        //[ApiActionAuthorize("删除表5蚕种生产情况统计表T_MulEggsProducStatist指定对象操作")]
        //[ApiActionException]
        public ResResult<int> Delete(string id)
        {
            return mulEggsProducStatistServices.DeleteInfo(id);
        }
        //[ApiActionAuthorize("获取表5蚕种生产情况统计表T_MulEggsProducStatist指定对象操作")]
        //[ApiActionException]
        public ResResult<MulEggsProducStatistEntity> Get(string id)
        {
            return mulEggsProducStatistServices.GetModel(id);
        }
        /// <summary>
        /// 导出下载响应
        /// </summary>
        /// <param name="ReportCode"></param>
        public void GetExcelData(string ReportCode, string FillInYear, string AreaCode)
        {
            AreaServices areaServices = new AreaServices();
            string AreaName = areaServices.GetByCodeModel(AreaCode).model.Name;
            MulNowModel model = new MulNowModel();
            model.AreaCode = AreaCode;
            model.FillInYear = FillInYear;
            model.ReportCode = ReportCode;
            //打开完成excel文件并下载
            HttpContext curContext = HttpContext.Current;
            // 设置编码和附件格式
            curContext.Response.AddHeader("Access-Control-Allow-Origin", "*");
            curContext.Response.ContentType = "application/vnd.ms-excel";
            curContext.Response.ContentEncoding = Encoding.UTF8;
            curContext.Response.Charset = "";
            string strFileName = model.FillInYear+AreaName + "全年蚕种生产情况统计表.xls";
            curContext.Response.AppendHeader("Content-Disposition",
                "attachment;filename=" + HttpUtility.UrlEncode(strFileName, Encoding.UTF8));
            curContext.Response.BinaryWrite(mulEggsProducStatistServices.Method(model).GetBuffer());
            curContext.Response.End();
        }

        public void GetStatsExcelData(string FillInYear, string AreaCode, string Status, string itemText)
        {
            MulNowModel model = new MulNowModel();
            model.FillInYear = FillInYear;
            model.AreaCode = AreaCode;
            model.Status = Status;
            model.itemText = itemText;
            //string ProvinceCode = "530000000000";
            AreaServices area = new AreaServices();
            List<MulEggsStatsModel> list = new List<MulEggsStatsModel>();
            if (!string.IsNullOrEmpty(model.AreaCode))
            {
                var listMulArea = mulEggsProducStatistServices.GetMulEggsProducStatsList(model);
                list = listMulArea.model;
            }
            //string AreaName = area.GetByCodeModel(model.AreaCode).model.Name;
            //打开完成excel文件并下载
            HttpContext curContext = HttpContext.Current;
            // 设置编码和附件格式
            curContext.Response.AddHeader("Access-Control-Allow-Origin", "*");
            curContext.Response.ContentType = "application/vnd.ms-excel";
            curContext.Response.ContentEncoding = Encoding.UTF8;
            curContext.Response.Charset = "";
            string strFileName = "";
            if (AreaCode != "530000000000")
            {
                string Name = area.GetByCodeModel(AreaCode).model.Name;
                strFileName = FillInYear + Name + "全年蚕种生产情况统计表.xls";
            }
            else
            {
                strFileName = FillInYear + "全省全年蚕种生产情况统计表.xls";
            }
            curContext.Response.AppendHeader("Content-Disposition",
                "attachment;filename=" + HttpUtility.UrlEncode(strFileName, Encoding.UTF8));
            curContext.Response.BinaryWrite(mulEggsProducStatistServices.MethodStats(list).GetBuffer());
            curContext.Response.End();
        }

       
    }
}